% if tb="study_15" then
Response.Redirect "list_graduate_graphic.asp?tb=study_15"
end if%>
<% if tb<>"" then %>
<%
page = request("page")
block = request("block")
if block="" then
block=0
end if
if page="" then
page=1
end if
%>
<% If request("search") <> "" then %>
<%
st=request("st")
sc=request("sc")
sn=request("sn")
%>
<%
search = trim(request("search"))
search = replace(search,"'","''")
if st="on" then
SQL2="(title LIKE '%"& search &"%')"
if sc="on" or sn="on" then
SQL2=SQL2 & " or "
end if
else
st="off"
end if
if sc="on" then
if st="on" then
SQL2=SQL2 & "(content LIKE '%"& search &"%')"
else
SQL2="(content LIKE '%"& search &"%')"
end if
if sn="on" then
SQL2=SQL2 & " or "
end if
else
sc="off"
end if
if sn="on" then
if st="on" or sc="on" then
SQL2=SQL2 & "(name LIKE '%"& search &"%')"
else
SQL2="(name LIKE '%"& search &"%')"
end if
else
sn="off"
end if
%>
<%
SQL = "SELECT * FROM "&tb&" where " & SQL2 & " ORDER BY re desc, reid asc, num DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.PageSize = recordset-1
rs.Open SQL,db,1
%>
<% else %>
<% if request("mode")="new" then %>
<%
if left(now,2) = "20" then
nowday = mid(now,3)
else
nowday = now
end if
nowday = left(nowday,8)
%>
<%
SQL = "SELECT * FROM "&tb&" where writeday LIKE '%"& nowday &"%' order by re DESC, reid ASC, num DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.PageSize = recordset-1
rs.Open SQL,db,1
%>
<% else %>
<%
SQL = "SELECT * FROM "&tb&" order by re DESC, reid ASC, num DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.PageSize = recordset
rs.Open SQL,db,1
%>
<% end if %><% end if %>
BOARD
<% 'ÇöÀç ÀúÀåµÈ ±ÛÀÌ ¾ø´Ù¸é..
if rs.BOF or rs.EOF then
%>
<% if request("mode")="new" or request("search")<>"" then %>
<%
Response.Redirect "error.asp?no=5"
%>
<% else %>
<%
Response.Redirect "write.asp?tb="&tb
%>
<% end if %>
<% 'ÇöÀç ÀúÀåµÈ ±ÛÀÌ ÀÖ´Ù¸é..
else
rs.Move rs.PageSize * (page-1)
record = rs.RecordCount
totalpage = rs.pagecount
rs.AbsolutePage = page
%>
<% if admin_notice<>"no" then %>
<% '------------------------ °øÁö»çÇ× ºÎºÐ -----------------------------------------
notice_SQL = "SELECT * FROM inno_notice where tb='"&tb&"' order by num DESC"
Set notice_rs = Server.CreateObject("ADODB.Recordset")
notice_rs.PageSize = notice_num
notice_rs.Open notice_SQL,db,1
if not (notice_rs.BOF or notice_rs.EOF) then
%>
<%
m=1
Do until notice_rs.EOF or m>notice_rs.pagesize
id=notice_rs("id")
name=notice_rs("name")
email=notice_rs("email")
url=notice_rs("url")
title=notice_rs("title")
tag=notice_rs("tag")
write_diff=notice_rs("writeday")
writeday=left(notice_rs("writeday"),8)
visit=notice_rs("visit")
content=notice_rs("content")
num=notice_rs("num")
filename=notice_rs("filename")
if filename="none" then
filename=""
end if
if email="none" then
email=""
end if
if num=0 then
num=""
end if
if left(now,2)="20" then
nowday=mid(now,3)
else
nowday=now
end if
if tag="tag_ok" then
title=CheckWord(title)
if Len(title) > 38 then
title=mid(title,1,39)&".."
end if
name=CheckWord(name)
If Len(name) > 15 Then
name = Mid(name,1,16) & ".."
End If
else
if Len(title) > 20 then
title=mid(title,1,21)&".."
end if
title=replace(title,""","'")
If Len(name) > 4 Then
name = Mid(name,1,5) & ".."
End If
name=replace(name,""","'")
end if
if search<>"" then
if st = "on" then
title = replace(title,search,""&search&"")
end if
if sn = "on" then
name = replace(name,search,""&search&"")
end if
end if
%>
°øÁö
<% if filename="" then %><% if DateDiff("d",write_diff,nowday) < newimg then %><% else %><% end if %><% else %><% if DateDiff("d",write_diff,nowday) < newimg then %><% else %><% end if %><% end if %> <%=title%>
<%
notice_rs.movenext
m=m+1
Loop
%>
<%
notice_rs.Close
set notice_rs=nothing
end if
'-------------------------------------------- °øÁö»çÇ× ³¡ºÎºÐ -------------------------------------------
%>
<% end if %>
<%
i=1
Do until rs.EOF or i>rs.pagesize
id=rs("id")
name=rs("name")
email=rs("email")
url=rs("url")
title=rs("title")
tag=rs("tag")
write_diff=rs("writeday")
writeday=left(rs("writeday"),8)
visit=rs("visit")
num=rs("num")
resame=rs("resame")
filename=rs("filename")
filesize=rs("filesize")
blank=4*resame
if filename="none" then
filename=""
filesize=""
end if
if num=0 then
num="--"
end if
if email="none" then
email=""
end if
if url="none" then
url=""
end if
if left(now,2)="20" then
nowday=mid(now,3)
else
nowday=now
end if
if tag="tag_ok" then
title=CheckWord(title)
if Len(title) > 38 then
title=mid(title,1,39)&".."
end if
name=CheckWord(name)
If Len(name) > 15 Then
name = Mid(name,1,16) & ".."
End If
else
if Len(title) > 30 then
title=mid(title,1,31)&".."
end if
title=replace(title,""","'")
If Len(name) > 4 Then
name = Mid(name,1,5) & ".."
End If
name=replace(name,""","'")
end if
if search<>"" then
if st = "on" then
title = replace(title,search,""&search&"")
end if
if sn = "on" then
name = replace(name,search,""&search&"")
end if
end if
%>
<% '---------- ÄÚ¸àÆ® ½ÃÀÛ --- %>
<%
com_SQL = "SELECT * FROM inno_comment where tb='"&tb&"' and com_num="&id
Set com_rs = Server.CreateObject("ADODB.Recordset")
com_rs.Open com_SQL,db,1
if rs.BOF or rs.EOF then
else
com_record = com_rs.RecordCount
end if
%>
<% '---------- ÄÚ¸àÆ® ³¡ --- %>